06. Quiz: POSITION, STRPOS, & SUBSTR - AME DATA AS QUIZ 1

Quizzes POSITION & STRPOS

You will need to use what you have learned about LEFT & RIGHT, as well as what you know about POSITION or STRPOS to do the following quizzes.

  1. Use the accounts table to create first and last name columns that hold the first and last names for the primary_poc.

  2. Now see if you can do the same thing for every rep name in the sales_reps table. Again provide first and last name columns.

Workspace

This section contains either a workspace (it can be a Jupyter Notebook workspace or an online code editor work space, etc.) and it cannot be automatically downloaded to be generated here. Please access the classroom with your account and manually download the workspace to your local machine. Note that for some courses, Udacity upload the workspace files onto https://github.com/udacity, so you may be able to download them there.

Workspace Information:

  • Default file path:
  • Workspace type: sql-evaluator
  • Opened files (when workspace is loaded): n/a

Next Concept